set hive.exec.dynamic.partition = true;
set hive.exec.dynamic.partition.mode = 'nonstrict';
set hive.exec.max.dynamic.partitions = 20;
set hive.exec.max.dynamic.partitions.pernode = 20;
insert overwrite table jms_dim.dim_abnormal_event_report_base_hi
select
    id
    ,code
    ,involved_type_id
    ,involved_type_desc
    ,involved_org_id
    ,involved_org_code
    ,involved_org_name
    ,involved_agent_id
    ,involved_agent_code
    ,involved_agent_name
    ,city_desc
    ,area_desc
    ,abnormal_type_id
    ,abnormal_type
    ,scene_name
    ,report_time
    ,happen_time
    ,end_time
    ,defer_day
    ,create_time
    ,update_time
from jms_ods.abnormal_event_report_hi
where dt='{{ execution_date | cst_ds }}'
;